{"text_format":"3","workbook":"xls","n_sheets":24,"sheets":["1","3","5","6","7A","7B","7C","8","9","10A","10B","10C","11A","11B","11C","12A","12B","13A","13B","Bar","Pareto","Histogram","Data Curve","Time Series"],"not_rendered":{"charts":8,"images":9,"external_links":1,"defined_names":15},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"1","index":0,"n_rows":30,"n_cols":14,"rows_kept":30,"flags":["formulas_cached_only"]}
[{"$nulls":7},"5 ▼",null,"6 ▼","7 ▼","8 ▼","14 ▼","15 ▼"]
[{"$nulls":7},"Score","Raw",null,"Deviation",null,"Std","z-score"]
[null,null,"Symbolic Formula","Function","Computed","Excel",null,"Number","Scores","Mean","Score",null,"Dev","Z ="]
["Name","Symbol"," See notes below","Name","Formula","Function",null,"i","X","x","X - x","(X - x)2","S","(X - x) / S"]
["Sum","SX","X1 + X2 + X3 . . . + Xn","SUM",null,null,"◄ 1",1,5]
["Sample Size","n","n =","COUNT",null,null,"◄ 2",null,6]
["Degrees of Freedom","d.f.","n - 1 =",{"$nulls":3},"◄ 3",null,7]
["Mean","x","sum/number = SX/n =","AVERAGE",null,null,"◄ 4",null,5]
["Sum of Squares","SS","S(X - x)2 =","DEVSQ",null,null,"◄ 9",null,3]
["Sample Variance","S2","SS/d.f. =","VAR",null,null,"◄10",null,8]
["Sample Standard Deviation","S","Ö(SS / d.f.) = ","STDEV",null,null,"◄11",null,7]
[null,null,"S/x",{"$nulls":3},"◄12",null,2]
["Sample Coefficient of Variation","Cvar","(S / x)*100",{"$nulls":3},"◄13",null,1]
["Legend",{"$nulls":7},5]
["Labels",null,"Check work with extra data set below"]
["Given Data",null,null,9]
["Order of Computation",null,null,8]
["Cells using formulas",null,null,7]
["Cells using functions",null,null,6]
["Cells using functions in a formula",null,null,5]
[{"$nulls":3},6]
["Notes:",null,null,7]
["Functions use raw scores as input",null,null,8]
["To take a square root you raise the number to the power of .5 (ex. 4^.5 = 2)",null,null,9]
[{"$nulls":3},9]
[{"$nulls":3},5]
[{"$nulls":3},6]
[]
[null,null,"Last Z score = ",-0.72]
[null,null,"CVAR=",18.75]

{"sheet":"3","index":1,"n_rows":44,"n_cols":13,"rows_kept":44,"flags":["formulas_cached_only"]}
[{"$nulls":7},"Raw",null,"Deviation",null,"Std","z-score"]
[null,null,"Symbolic","Function","Computed","Excel","Score","Scores","Mean","Score",null,"Dev","Z ="]
["Name","Symbol","Formula","Name","Formula","Function","Number","X","x","X - x","(X - x)2","S","(X - x) / S"]
["Sum","SX","X1 + X2 + X3 . . . + Xk","SUM",null,87,1,11,{"v":5.8,"d":"5.80"},{"v":5.2,"d":"5.20"},{"v":27.040000000000003,"d":"27.04"},{"v":2.8585710716070314,"d":"2.86"},{"v":1.8190906819317472,"d":"1.82"}]
["Sample Size","n","n =","COUNT",null,15,2,10,{"v":5.8,"d":"5.80"},{"v":4.2,"d":"4.20"},17.64,{"v":2.8585710716070314,"d":"2.86"},{"v":1.4692655507910266,"d":"1.47"}]
["Degrees of Freedom","d.f."," n - 1",null,14,null,3,9,{"v":5.8,"d":"5.80"},{"v":3.2,"d":"3.20"},{"v":10.240000000000002,"d":"10.24"},{"v":2.8585710716070314,"d":"2.86"},{"v":1.119440419650306,"d":"1.12"}]
["Mean","x","sum/number = SX/n","AVERAGE",{"v":5.8,"d":"5.80"},{"v":5.8,"d":"5.80"},4,8,{"v":5.8,"d":"5.80"},{"v":2.2,"d":"2.20"},{"v":4.840000000000001,"d":"4.84"},{"v":2.8585710716070314,"d":"2.86"},{"v":0.7696152885095854,"d":"0.77"}]
["Sum of Squares","SS"," S(X - x)2","SUM, DEVSQ",null,{"v":114.4,"d":"114.40"},5,7,{"v":5.8,"d":"5.80"},{"v":1.2000000000000002,"d":"1.20"},{"v":1.4400000000000004,"d":"1.44"},{"v":2.8585710716070314,"d":"2.86"},{"v":0.41979015736886477,"d":"0.42"}]
["Mode","Mode","Mode = ","MODE",null,{"v":6,"d":"6.00"},6,6,{"v":5.8,"d":"5.80"},{"v":0.20000000000000018,"d":"0.20"},{"v":0.04000000000000007,"d":"0.04"},{"v":2.8585710716070314,"d":"2.86"},{"v":0.06996502622814418,"d":"0.07"}]
["Median","Median","Median =","MEDIAN",null,{"v":6,"d":"6.00"},7,5,{"v":5.8,"d":"5.80"},{"v":-0.7999999999999998,"d":"-0.80"},{"v":0.6399999999999997,"d":"0.64"},{"v":2.8585710716070314,"d":"2.86"},{"v":-0.2798601049125764,"d":"-0.28"}]
["Minimum","Min","Minimum =","MIN",null,{"v":1,"d":"1.00"},8,4,{"v":5.8,"d":"5.80"},{"v":-1.7999999999999998,"d":"-1.80"},{"v":3.2399999999999993,"d":"3.24"},{"v":2.8585710716070314,"d":"2.86"},{"v":-0.6296852360532971,"d":"-0.63"}]
["Maximum","Max","Maximum =","MAX",null,{"v":11,"d":"11.00"},9,3,{"v":5.8,"d":"5.80"},{"v":-2.8,"d":"-2.80"},{"v":7.839999999999999,"d":"7.84"},{"v":2.8585710716070314,"d":"2.86"},{"v":-0.9795103671940176,"d":"-0.98"}]
["Range","Range","Range = Max - Min",null,{"v":10,"d":"10.00"},null,10,2,{"v":5.8,"d":"5.80"},{"v":-3.8,"d":"-3.80"},14.44,{"v":2.8585710716070314,"d":"2.86"},{"v":-1.3293354983347383,"d":"-1.33"}]
["Sample Variance","S2","SS/d.f. =","VAR",{"v":8.171428571428573,"d":"8.17"},{"v":8.171428571428569,"d":"8.17"},11,1,{"v":5.8,"d":"5.80"},{"v":-4.8,"d":"-4.80"},23.04,{"v":2.8585710716070314,"d":"2.86"},{"v":-1.6791606294754589,"d":"-1.68"}]
["Sample Standard Deviation","S","Ö(SS / d.f.)","STDEV",{"v":2.8585710716070314,"d":"2.86"},{"v":2.858571071607031,"d":"2.86"},12,5,{"v":5.8,"d":"5.80"},{"v":-0.7999999999999998,"d":"-0.80"},{"v":0.6399999999999997,"d":"0.64"},{"v":2.8585710716070314,"d":"2.86"},{"v":-0.2798601049125764,"d":"-0.28"}]
["Population Variance","s2","S(X - m)2/N ","VARP",{"v":7.626666666666667,"d":"7.63"},{"v":7.626666666666667,"d":"7.63"},13,4,{"v":5.8,"d":"5.80"},{"v":-1.7999999999999998,"d":"-1.80"},{"v":3.2399999999999993,"d":"3.24"},{"v":2.8585710716070314,"d":"2.86"},{"v":-0.6296852360532971,"d":"-0.63"}]
["Population Standard Deviation","s","Ö(S(X-m)2/N) ","STDEVP",{"v":2.7616420236277306,"d":"2.76"},{"v":2.7616420236277306,"d":"2.76"},14,6,{"v":5.8,"d":"5.80"},{"v":0.20000000000000018,"d":"0.20"},{"v":0.04000000000000007,"d":"0.04"},{"v":2.8585710716070314,"d":"2.86"},{"v":0.06996502622814418,"d":"0.07"}]
[null,null,"S / x",null,{"v":0.49285708131155714,"d":"0.49"},null,15,6,{"v":5.8,"d":"5.80"},{"v":0.20000000000000018,"d":"0.20"},{"v":0.04000000000000007,"d":"0.04"},{"v":2.8585710716070314,"d":"2.86"},{"v":0.06996502622814418,"d":"0.07"}]
["Sample Coefficient of Variation","Cvar","(S / x)*100",null,{"v":49.285708131155715,"d":"49.29"}]
[]
[null,null,"Check work with extra data set below",{"$nulls":3},"Old Diet","New Diet"]
[null,null,5,{"$nulls":3},300,301]
[null,null,6,{"$nulls":3},285,281]
[null,null,7,{"$nulls":3},310,300]
[null,null,8,{"$nulls":3},267,250]
[null,null,9,{"$nulls":3},309,300]
[null,null,8,{"$nulls":3},293,245]
[null,null,7,{"$nulls":3},310,301]
[null,null,6,{"$nulls":3},267,232]
[null,null,5,{"$nulls":3},325,302]
[null,null,4,{"$nulls":3},301,300]
[null,null,3]
[null,null,2]
[null,null,1]
[null,null,2]
[null,null,3]
[null,null,"Coefficient of Variation = Cvar = (S/x)*100",null,49.18207130360314]
[null,null,"Last Z score =",null,-0.829356564354829,"Average",296.7,281.2]
[{"$nulls":5},"Sum",2967,2812]
[{"$nulls":5},"Variance",361.12222222221965,775.7333333333307]
[{"$nulls":5},"Std. Dev.",19.003216102076504,27.85198975537171]
[{"$nulls":5},"Min",267,232]
[{"$nulls":5},"Max",325,302]
[{"$nulls":5},"Range",58,70]

{"sheet":"5","index":2,"n_rows":19,"n_cols":15,"rows_kept":19,"flags":["formulas_cached_only"]}
["Binomial Distribution"]
["Successes","X =",1]
["Trials","n =",50,null,40,41,42,43,44,45,46,47,48,49,50]
["Probability","p =",0.03,null,{"v":9.209462904274206e-52,"d":"0.000"},{"v":6.947042673578847e-54,"d":"0.000"},{"v":4.604078355096384e-56,"d":"0.000"},{"v":2.649193970805848e-58,"d":"0.000"},{"v":1.3034928160010253e-60,"d":"0.000"},{"v":5.37522810722066e-63,"d":"0.000"},{"v":1.8070018289626013e-65,"d":"0.000"},{"v":4.756311021616793e-68,"d":"0.000"},{"v":9.193900170651172e-71,"d":"0.000"},{"v":1.1606017467684912e-73,"d":"0.000"},{"v":7.178979876918419e-77,"d":"0.000"}]
["Cumulative (True) or Point (False)","T or F?",true]
["p =Area at and below [BINOMDIST]","P(S) < =",{"v":0.5552798733073154,"d":"0.5553"}]
["Area Above (1-p)","P(S) > ",{"v":0.44472012669268457,"d":"0.4447"}]
["Cumulative (True) or Point (False)","T or F?",false]
["p = Area in the interval [BINOMDIST]","P(S) =",{"v":0.33721449795990815,"d":"0.3372"}]
["Compliment (1-p)","P(S) /=",{"v":0.6627855020400919,"d":"0.6628"}]
[]
[]
[]
[]
["Check work with extra data set below"]
["X =",5]
["n =",8]
["p =",0.2]
["Complement",0.99082496]

{"sheet":"6","index":3,"n_rows":21,"n_cols":6,"rows_kept":21,"flags":["formulas_cached_only"]}
[null,null,"Poisson Distribution"]
[{"$nulls":3},"What are you given?"]
[]
[null,null,"Outcomes and Occasions","Mean (l)","Probability"]
[null,"Total outcomes in population =",900,null,0.02,"= probability (p)"]
[null,"Occasions in population =",7000,null,150,"= occasions (n)"]
["Specific Outcome in sample =","X =",2,8,3,"= X"]
["Mean = Total Outcomes/Occasions","l =",{"v":0.12857142857142856,"d":"0.1286"},5,3,"= n*p = l = mean"]
["Cumulative (True) or Point (False) =","T or F ?",true,true,true]
["p = Area at and below [POISSON] =","P(X:l) < =",{"v":0.9996782346068158,"d":"0.9997"},{"v":0.9319063652781508,"d":"0.9319"},{"v":0.6472318887822313,"d":"0.6472"},"[POISSON]"]
["p = Area Above (1 - p) =","P(X:l) >",{"v":0.0003217653931841813,"d":"0.0003"},{"v":0.06809363472184915,"d":"0.0681"},{"v":0.35276811121776874,"d":"0.3528"},"= 1- p"]
["Cumulative (True) or Point (False)","T or F?",false,false,false]
["p = Area at the Point [POISSON]","P(X:l) =",{"v":0.007268103132856301,"d":"0.0073"},{"v":0.06527803934815869,"d":"0.0653"},{"v":0.22404180765538775,"d":"0.2240"},"[POISSON]"]
["p = Complement (1 -  p)","P(X:l) /=",{"v":0.9927318968671437,"d":"0.9927"},{"v":0.9347219606518413,"d":"0.9347"},{"v":0.7759581923446123,"d":"0.7760"},"= 1- p"]
[]
["Check work with extra data set below"]
[null,"Specific Outcome in sample",3,6,5,"= X"]
[null,"Total Outcomes in Population =",500,null,0.02,"= probability (p)"]
[null,"Occasions in Population=",600,null,400,"= occasions (n)"]
[null,"mean (l) =",{"v":0.8333333333333334,"d":"0.8333"},5,8,"= mean = (l)"]
[null,"Complement =",0.9581,{"v":0.8537771918601246,"d":"0.8538"},{"v":0.9083963384074208,"d":"0.9084"},"= Complement"]

{"sheet":"7A","index":4,"n_rows":21,"n_cols":6,"rows_kept":21,"merged":[[0,2,0,5]],"flags":["formulas_cached_only"]}
[null,null,"Gaussian Distribution Problems"]
["Name","Symbol","Explanation","Score #1","Score #2","Explanation"]
["Score","X","Raw score from which you wish to determine the area",50,15,"The second score (optional)"]
["Mean","x or m","The mean of the distribution of scores",45,45,"Cell reference to Column d"]
["Standard Deviation","S or s","The standard deviation of that distribution",3,3,"Cell reference to Column d"]
["Population Size","N","The number of scores in the distribution (optional)",200,200,"Cell reference to Column d"]
["Deviation Score","X - x","Deviation of the score from the mean of the distribution",5,-30]
["z-score","Z","z-score = Deviation / Std. Deviation = (X - x) / S",1.6666666666666667,-10]
[{"$nulls":3},"Area","Area","Area between 2 scores"]
["probability below","p ","Area below the score [NORMSDIST]",{"v":0.9522096695900616,"d":"0.9522"},{"v":0,"d":"0.0000"},{"v":-0.9522096695900616,"d":"-0.9522"}]
["probability above","1 - p","Area above the score (1 -p)",{"v":0.04779033040993841,"d":"0.0478"},{"v":1,"d":"1.0000"}]
[{"$nulls":3},"Number","Number","Number between 2 scores"]
["Number below","#","Number below the score = N * p =",{"v":190.44193391801232,"d":"190"},0,{"v":-190.44193391801232,"d":"-190.4419"}]
["Number above","#","Number above the score = N * (1 - p) =",{"v":9.558066081987683,"d":"10"},200]
[]
[null,null,"Check work with extra data set below"]
[{"$nulls":3},"Score #1","Score #2","Between 2"]
[null,null,"X =",270,279,{"v":0.020884181895792553,"d":"0.0209"}]
[null,null,"Mean = SX / n =",250]
[null,null,"Std. Dev. = ",10,null,"Between 2"]
[null,null,"N =",400,null,{"v":8.353672758317032,"d":"8"}]

{"sheet":"7B","index":5,"n_rows":22,"n_cols":6,"rows_kept":22,"flags":["formulas_cached_only"]}
["Gaussian Distribution from Area (p) (or Number of Scores (#))  to a Cutoff Score (X)"]
["What information are you given? ",null,"Proportion (Use C)  ",null,"# of scores (Use E)"]
["Mean","x or m",375,null,72]
["Standard Deviation","s or S",35,null,2.5]
["Number of scores in an area","#",null,null,11000]
["Total number of scores represented by the entire distribution","N",null,null,200000]
["Proportion of the area of the curve of interest","p = # / N",{"v":0.22,"d":"0.2200"},"Right",{"v":0.055,"d":"0.0550"},"Right"]
[null,"1 - p",{"v":0.78,"d":"0.7800"},"Left",{"v":0.945,"d":"0.9450"},"Left"]
[null,"On which side of the scores do you want the cutoff?","Right","Left","Right","Left"]
["C10 is a reference to C7 and D10 to C8, E10 to D7 & F10 to D8","p =",{"v":0.22,"d":"0.2200"},{"v":0.78,"d":"0.7800"},{"v":0.055,"d":"0.0550"},{"v":0.945,"d":"0.9450"}]
["[NORMSINV] gives the z-score assciciated with areas in D11:F11","z =",{"v":-0.7721929781867702,"d":"-0.77"},{"v":0.7721929781867702,"d":"0.77"},{"v":-1.5981931246472616,"d":"-1.60"},{"v":1.5981931246472612,"d":"1.60"}]
["Standard Deviation from Row 4","S =",35,35,2.5,2.5]
["Deviation Score","Z * S =",{"v":-27.02675423653696,"d":"-27.03"},{"v":27.02675423653696,"d":"27.03"},{"v":-3.995482811618154,"d":"-4.00"},{"v":3.995482811618153,"d":"4.00"}]
["Mean from row 3","x =",375,375,72,72]
["X = Cutoff score = Deviation + Mean = (X - x) + x","X =",{"v":347.97324576346307,"d":"347.97"},{"v":402.02675423653693,"d":"402.03"},{"v":68.00451718838184,"d":"68.00"},{"v":75.99548281161816,"d":"76.00"}]
[]
["Check work with extra data set below"]
["Mean  (x or m)=","x or m",null,null,72]
["Standard Deviation (s or S) =","s or S",null,null,15]
["Number of scores in an area","#",null,null,250]
["Total number of scores represented by the entire distribution =","N",null,null,6500]
["X = Cutoff score = Deviation + Mean =","X",null,null,{"v":45.47449607332237,"d":"45.47"},{"v":98.52550392667763,"d":"98.53"}]

{"sheet":"7C","index":6,"n_rows":25,"n_cols":6,"rows_kept":25,"merged":[[0,2,0,5]],"flags":["formulas_cached_only"]}
[null,null,"Gaussian Distribution Problems"]
["Name","Symbol","Explanation","Score #1","Score #2","Explanation2"]
["Sample mean","x","Given information",55,55,"The second score (optional)"]
["Population mean","m","Given information",48,48,"Cell reference to Column d"]
["Pop. Std. Dev","S or s","Given information",11,11,"Cell reference to Column d"]
["Size or each sample"," n","Given information",10,10,"Cell reference to Column d"]
["Population Size","N","(optional) Given information ",234,234,"Cell reference to Column d"]
["Deviation Score","x - m","Deviation of the sample mean from the pop. mean",7,7,"= x - m"]
["Square Root of n","√n","Square root of the sample size =",3.1622776601683795,3.1622776601683795,"= n^.5"]
["Standard Error ","S / √n","Standard error of the mean (Std. Dev. of the means) ",3.478505426185217,3.478505426185217,"= S / √n"]
["z-score","Z","z-score = Deviation / Standard Error",2.0123585110162416,2.0123585110162416,"= (x - m) / sx "]
[{"$nulls":3},"Area","Area","Area between 2 scores"]
["probability below","p ","Area below the score [NORMSDIST]",{"v":0.9779089902375959,"d":"0.9779"},{"v":0.9779089902375959,"d":"0.9779"},{"v":0,"d":"0.0000"}]
["probability above","1 - p","Area above the score (1 -p)",{"v":0.02209100976240408,"d":"0.0221"},{"v":0.02209100976240408,"d":"0.0221"}]
[{"$nulls":3},"Number","Number","Number between 2 scores"]
["Number below","#","Number below the score = N * p =",{"v":228.83070371559745,"d":"229"},{"v":228.83070371559745,"d":"229"},{"v":0,"d":"0.0000"}]
["Number above","#","Number above the score = N * (1 - p) =",{"v":5.169296284402554,"d":"5"},{"v":5.169296284402554,"d":"5"}]
[]
[null,null,"Check work with extra data set below"]
[{"$nulls":3},"Mean #1","Mean # 2","Between 2"]
[null,null,"Sample mean = x =",45,46,{"v":0.14498163314579493,"d":"0.1450"}]
[null,null,"Population Mean = m =",47]
[null,null,"Population Standard Deviation = s =",6,null,"Between 2"]
[null,null,"Sample size = n =",31,null,{"v":72.49081657289746,"d":"72"}]
[null,null,"Population Size = N =",500]

{"sheet":"8","index":7,"n_rows":61,"n_cols":6,"rows_kept":61,"flags":["formulas_cached_only"]}
[null,"Confidence Interval for the Mean"]
[{"$nulls":4},"Is population standard deviation (s) known?"]
["Name","Formula or Function",null,"Yes","No"]
["Sample Mean","Given","x",93,93,"Point estimate"]
["Standard Deviation","Given","s or s",7,7,"Either s (preferred) or s"]
["Sample Size","Given","n",20,20,"Cell reference to D"]
["Confidence Level","Given","CI",95,95,"Usually 90. 95, 99 or 99.9"]
["Degrees of Freedom","n - 1","d.f.",null,19,"Degrees of freedom"]
["Square Root of Sample Size","n^.5","Ön",{"v":4.47213595499958,"d":"4.47"},{"v":4.47213595499958,"d":"4.47"},"Needed to compute sx"]
["Standard Error of the Mean"," s / Ön","sx",{"v":1.5652475842498528,"d":"1.57"},{"v":1.5652475842498528,"d":"1.57"},"Needed to compute precision"]
["Area in tails as %","100 - CI","%",5,5,"Used to compute a"]
["Area in 2 tails as proportion","% / 100","a",0.05,0.05,"Used with t"]
["Area in one tail","a / 2","a / 2",0.025,null,"Used only with Z"]
["Distribution",null,"Distribution =","Z","t","Distribution"]
["Critical Value","NORMSINV, TINV","C.V.",{"v":-1.959962787408407,"d":"-1.96"},{"v":2.0930247046635486,"d":"2.09"},"Function yields cutoff"]
["Precision","CV * sx",null,{"v":-3.067827018210617,"d":"-3.07"},{"v":3.276101862749881,"d":"3.28"},"Area on either side of mean"]
["Absolute value of Precision","ABS",null,{"v":3.067827018210617,"d":"3.07"},{"v":3.276101862749881,"d":"3.28"},"Makes sure it is positive"]
["Lower Confidence Limit","x - |precision|","LCL",{"v":89.93217298178938,"d":"89.93"},{"v":89.72389813725012,"d":"89.72"},"Cutoff below mean"]
["Upper Confidence Limit","x + |precision|","UCL",{"v":96.06782701821062,"d":"96.07"},{"v":96.27610186274988,"d":"96.28"},"Cutoff above mean"]
["Interpretation: The population mean will fall  between the LCL and UCL in the specified % of such intervals."]
["Check work with extra data set below"]
[null,null,"x =",56]
[null,null," s or s =",8]
[null,null," n =",32]
[null,null," CI =",95]
[null,null," UCL =",{"v":58.771803544341324,"d":"58.77"},{"v":58.88430918518752,"d":"58.88"}]
[]
[]
[]
[null,null,25]
[null,null,0]
[null,null,22]
[null,null,43]
[null,null,15]
[null,null,0]
[null,null,19]
[null,null,9]
[null,null,12]
[null,null,5]
[null,null,18]
[null,null,51]
[null,null,11]
[null,null,55]
[null,null,21]
[null,null,24]
[null,null,36]
[null,null,60]
[null,null,20]
[null,null,26]
[null,null,42]
[null,null,10]
[null,null,17]
[null,null,29]
[null,null,17]
[null,null,20]
[null,null,24]
[null,null,26]
[null,null,21]
[null,null,32]
[null,"Mean",23.666666666666668]
[null,"Standard Deviation",14.914314654357922]

{"sheet":"9","index":8,"n_rows":33,"n_cols":8,"rows_kept":33,"flags":["formulas_cached_only"]}
["One sample test of mean","Formula, Function",null,"Distribution"]
["Name","or Explanation","Symbol","Z","t"]
[null,null,"Is population standard deviation (s) known?","Yes","No"]
["Sample Mean","Observed","x",93,93]
["Pooulation Mean","Expected or Hypothesised","m",95,95]
["Standard Deviation ","Sample or Population","s or s",7,7]
["Sample Size","number of scores","n ",20,20]
["Acceptable risk","Type 1 error","a",0.05,0.05,"for t"]
["Deviation Score","Observed-expected diff.","x - m",-2,-2]
["Square Root of sample size","n^.5","Ön ",{"v":4.47213595499958,"d":"4.47"},{"v":4.47213595499958,"d":"4.47"}]
["Standard Error of the Mean","standard deviation / Ö n ","s x  ",{"v":1.5652475842498528,"d":"1.57"},{"v":1.5652475842498528,"d":"1.57"}]
["Degrees of Freedom","n - 1","d.f.",null,19,"for t"]
["Test Statistic","deviation / standard error","t or z",{"v":-1.2777531299998799,"d":"-1.28"},{"v":-1.2777531299998799,"d":"-1.28"}]
["Absolute Value","|TS|","|TS|",{"v":1.2777531299998799,"d":"1.28"},{"v":1.2777531299998799,"d":"1.28"},"for t"]
["Negative of AV","-1 * |TS|",null,{"v":-1.2777531299998799,"d":"-1.28"},null,"for z"]
["Distribution",null,null,"Z","t","Tails"]
["1 Tailed probability ","NORMSDIST, TDIST","p1",{"v":0.10066830831383111,"d":"0.1007"},{"v":0.10836413317940213,"d":"0.1084"},1,"Accept H0","Accept H0"]
["2 Tailed probability","2*p1","p2",{"v":0.20133661662766222,"d":"0.2013"},{"v":0.21672826635880427,"d":"0.2167"},2,"Accept H0","Accept H0"]
["Confidence Intervals"]
["Area in one tail","a / 2","a / 2",0.025,null,"for z"]
["Critical Value","NORMSINV, TINV","C.V.",{"v":-1.959962787408407,"d":"-1.96"},{"v":2.0930247046635486,"d":"2.09"}]
["Precision","CV * sx",null,{"v":-3.067827018210617,"d":"-3.07"},{"v":3.276101862749881,"d":"3.28"}]
["Absolute value of Precision","ABS","|CV * sx|",{"v":3.067827018210617,"d":"3.07"},{"v":3.276101862749881,"d":"3.28"}]
["Lower Confidence Limit","x - |precision|","LCL",{"v":89.93217298178938,"d":"89.93"},{"v":89.72389813725012,"d":"89.72"}]
["Upper Confidence Limit","x + |precision|","UCL",{"v":96.06782701821062,"d":"96.07"},{"v":96.27610186274988,"d":"96.28"}]
[]
[]
[null,null,"Check work with extra data set below"]
["Sample Mean","Observed","x",22]
["Pooulation Mean","Expected or Hypothesised","m",26]
["Standard Deviation ","Sample or Population","s or s",9]
["Sample Size","number of scores","n ",32]
["2 Tailed probability","2*p1","p2",{"v":0.011931750221713333,"d":"0.0119"},{"v":0.017335980215634744,"d":"0.0173"},2]

{"sheet":"10A","index":9,"n_rows":36,"n_cols":9,"rows_kept":36,"flags":["formulas_cached_only"]}
[null,"Two Sample Mean Test"]
["Name","Formula or Function","Symbol","Group 1",null,"Group 2",null,"Difference"]
["Sample Means","x1 - x2",null,{"v":134,"d":"134.00"},"-",{"v":143,"d":"143.00"},"=",{"v":-9,"d":"-9.00"}]
["Population Means (optional) ","m1 - m2",null,null,"-",null,"=",{"v":0,"d":"0.00"}]
["Deviation of observed difference from expected","(x1 - x2) - (m1 - m2) ",{"$nulls":5},{"v":-9,"d":"-9.00"}]
["Standard deviations","S or s",null,{"v":9,"d":"9.00"},null,{"v":13,"d":"13.00"}]
["Variances","S2 or s2",null,{"v":81,"d":"81.0"},null,{"v":169,"d":"169.0"}]
["Sample sizes","n1 + n2","N",10,null,14,null,"Sum ↓"]
["Degrees of freedom"," df1+ df2 = (n1 - 1) + (n2 - 1)","d.f.total",9,null,13,null,22,"← t equal"]
["Unequal Sample Size Correction Factor","1/n1 + 1/n2","CF",{"v":0.1,"d":"0.100"},null,{"v":0.07142857142857142,"d":"0.071"},null,{"v":0.17142857142857143,"d":"0.171"},"← t equal"]
["Sum of Squares ","df1*S12+df2*S22","SS",729,null,2197,null,2926,"← t equal"]
["Pooled Variance of Difference","SS/d.f.",{"$nulls":5},133,"← t equal"]
["Ajusted Pooled Variance of Difference","SS/d.f.*CF","s2x1-x2",{"$nulls":4},{"v":22.8,"d":"22.80"},"← t equal"]
["Variance / n ","S12 /n1 + S22/n2",null,{"v":8.1,"d":"8.10"},null,{"v":12.071428571428571,"d":"12.07"},null,{"v":20.17142857142857,"d":"20.17"},"← z & t unequal"]
["Smaller of d.f.1 or d.f.2 =","IF","d.f.smaller",9,null,"←t unequal",null,"t equal ↓"]
["Std. error col. D for Z & t unequal col. H for t equal","Ö[(S12 /n1) + (S22/n2)]","sx1-x2",{"v":4.491261356392942,"d":"4.49"},null,"← z & t unequal",null,{"v":4.774934554525329,"d":"4.77"}," Ö[(SS/d.f.)*CF]"]
["Test Statistic [t (unequal) or z]","deviation / standard error","TS",{"v":-2.0038913983906186,"d":"-2.00"},null,"← z & t unequal",null,{"v":-1.8848425873126298,"d":"-1.8848"},"← t equal"]
["Absolute Value of Test Statistic","ABS"," |TS| ",{"v":2.0038913983906186,"d":"2.00"},null,"← t unequal",null,{"v":1.8848425873126298,"d":"1.8848"},"← t equal"]
["Negative of absolute value","-1 * |TS|",null,{"v":-2.0038913983906186,"d":"-2.00"},null,"← z & t unequal"]
[null,"Are the population standard deviations (s's) known? ",null,"Yes ¯",null,"No, are s's equal?",null,"Default","← see 10B if No"]
[{"$nulls":3}," ¯",null,"No ¯",null,"Yes ¯"]
[{"$nulls":3},"Z",null,"t (unequal s2)",null,"t (equal s2)","Tails"]
["1 Tailed probability ","area of the curve in the left tail","p1",{"v":0.022540777761180908,"d":"0.0225"},null,{"v":0.038036985035261844,"d":"0.0380"},null,{"v":0.03636502772128507,"d":"0.0364"},1]
["2 Tailed probability","area of the curve in both tails","p2",{"v":0.045081555522361816,"d":"0.0451"},null,{"v":0.07607397007052369,"d":"0.0761"},null,{"v":0.07273005544257014,"d":"0.0727"},2]
[null,"a",0.05,"Reject H0",null,"Reject H0",null,"Reject H0"]
[null,"Check work with extra data set below",null,"Reject H0",null,"Accept H0",null,"Accept H0"]
[null,"x1 - x2",null,{"v":45,"d":"45.00"},"-",{"v":52,"d":"52.00"}]
[null,"m1 - m2",null,null,"-"]
[null,"(x1 - x2) - (m1 - m2) "]
[null,"S or s",null,{"v":21,"d":"21.00"},null,{"v":24,"d":"24.00"}]
[null,"S2 or s2",null,{"v":441,"d":"441.0"},null,{"v":576,"d":"576.0"}]
[null,"n1 + n2","N",32,null,21]
[]
[{"$nulls":3},"Z",null,"t (unequal)",null,"t (equal)"]
[null,null,"p1",{"v":0.13776198915110305,"d":"0.1378"},null,{"v":0.14424384636536214,"d":"0.1442"},null,{"v":0.13365970305368013,"d":"0.1337"}]
[null,null,"p2",{"v":0.2755239783022061,"d":"0.2755"},null,{"v":0.2884876927307243,"d":"0.2885"},null,{"v":0.26731940610736027,"d":"0.2673"}]

{"sheet":"10B","index":10,"n_rows":21,"n_cols":6,"rows_kept":21,"flags":["formulas_cached_only"]}
[null,"F Test"]
["Name","Function or Formula","Symbol","Group 1","Group 2"]
["Sample sizes","Given information","n ",10,12]
["Standard Deviations","Given information","S ",{"v":7.1,"d":"7.10"},{"v":4.2,"d":"4.20"}]
["Degrees of freedom","n -1 for each sample"," d.f.",9,11]
["Variance","S^2 or could be given info","S2",50.41,17.64]
[{"$nulls":3},"Larger","Smaller"]
["Variance ","Use IF(…) to select larger variance, smaller variance","S2 ",50.41,17.64]
["Degrees of freedom ","Use IF(…) to select d.f. for larger variance, smaller variance"," d.f. ",9,11]
["Test Statistic: F Test","SL2 / SS2","F",{"v":2.8577097505668934,"d":"2.8577"}]
[{"$nulls":3},"P(F)","Tails"]
["Probability in 1 tail","FDIST","p1",{"v":0.05208705085622997,"d":"0.0521"},1,"Accept H0 - Population variances are likely equal"]
["Probability in 2 tails","2 * p1","p2",{"v":0.10417410171245994,"d":"0.1042"},2,"Accept H0 - Population variances are likely equal"]
[null,"a",0.05]
[null,"Check work with extra data set below"]
[{"$nulls":3},"Group 1","Group 2"]
[null,"Sample size = n =",null,24,29]
[null,"Standard Deviations = S =",null,{"v":5.3,"d":"5.30"},{"v":8.2,"d":"8.20"}]
[null,"Probability for 2  tails =",null,{"v":0.03594948843103912,"d":"0.0359"},2]
[null,"a",0.05,"Reject H0"]
["USE TO TEST T EQUAL OR T UNEQUAL IN 10A IF SAMPLES ARE NORMALLY DISTRIBUTED"]

{"sheet":"10C","index":11,"n_rows":29,"n_cols":8,"rows_kept":29,"flags":["formulas_cached_only"]}
["Dependent t test",{"$nulls":4},"X","X"]
["Name","Formula or Function","Symbol",null,"Group",1,2,"D "]
["Mean","AVERAGE of each group","x",null,null,88.66666666666667,80.55555555555556,"Difference"]
["Sample Standard Deviation","STDEV","S",null,null,6.652067347825035,3.6094013046178963," X1 - X2 ↓"]
["Mean of the differences","AVERAGE of difference","D",{"v":8.11111111111111,"d":"8.11"},null,85,83,2]
["Expected difference (if given)","Expected difference (if given)","mD",null,null,91,82,9]
["Deviation"," D - mD",null,{"v":8.11111111111111,"d":"8.11"},null,94,80,14]
["Standard Deviation of the Differences","STDEV","SD",{"v":5.134307266916455,"d":"5.13"},null,83,77,6]
["Sample size","COUNT","np",9,null,81,81,0]
["Square Root of Sample Size","np^.5","Önp ",3,null,79,73,6]
["Standard Error of the Differences","SD / Ö np","sD",{"v":1.7114357556388182,"d":"1.71"},null,94,85,9]
["Test statistic: t-test","deviation / standard error","t",{"v":4.739360554076726,"d":"4.74"},null,95,83,12]
["Absolute value of Test statistics","ABS","|t|",{"v":4.739360554076726,"d":"4.74"},null,96,81,15]
["Degrees of freedom","np -1 =","d.f.D ",8,{"$nulls":3},""]
[{"$nulls":3},"P(t)","Tails",null,null,""]
["1 Tailed probability (left tail)","TDIST","p1",{"v":0.000732580541627953,"d":"0.0007"},1,null,null,""]
["2 Tailed probability (both tails)","2*p1","p2",{"v":0.001465161083255906,"d":"0.0015"},2,null,null,""]
[null,"a",0.01,"p<a - Reject H0",{"$nulls":3},""]
[{"$nulls":3},"p<a - Reject H0"]
[null,"Check work with extra data set below"]
[null,null,1,2]
[null,null,24,26]
[null,null,22,25]
[null,null,21,22]
[null,null,23,21]
[null,null,24,29]
[null,null,29,31]
[null,null,"Probability for 1 tail",{"v":0.05514161710156499,"d":"0.0551"}]
[null,null,"Probability for 2 tails",{"v":0.11028323420312998,"d":"0.1103"}]

{"sheet":"11A","index":12,"n_rows":33,"n_cols":12,"rows_kept":33,"flags":["formulas_cached_only"]}
["Pearson Correlation","Formula or",{"$nulls":4},"3↓","4↓",null,"5↓","6↓","7↓"]
["Name","Function","Symbol",null,null,"X","X - x","ZX","Y","Y - ŷ","ZY","ZxZy"]
["Mean of X, Y","AVERAGE","x, ŷ",null,"1→",0.7999999999999999,null,null,1.5250000000000001]
["Sample Standard Deviation of X, Y","STDEV","S",null,"2→",0.8318653737234168,null,null,0.22079402165819553]
["Sum of ZxZy =","SUM","SZxZy",{"v":4.872845907858898,"d":"4.87"},"←8",0,{"v":-0.7999999999999999,"d":"-0.8"},{"v":-0.96169407366869,"d":"-0.96"},1.25,{"v":-0.27500000000000013,"d":"-0.3"},{"v":-1.2455047375590595,"d":"-1.25"},{"v":1.1977945248368247,"d":"1.20"}]
["Sample Size","number of pairs ","n ",{"v":6,"d":"6.00"},"←9",0.1,-0.7,{"v":-0.8414823144601037,"d":"-0.84"},1.35,{"v":-0.17500000000000004,"d":"-0.2"},{"v":-0.7925939239012195,"d":"-0.79"},{"v":0.6669537695114135,"d":"0.67"}]
["Degrees of freedom for r","n - 1","d.f.1",{"v":5,"d":"5.00"},"←10",0.2,{"v":-0.5999999999999999,"d":"-0.6"},{"v":-0.7212705552515174,"d":"-0.72"},1.4,{"v":-0.12500000000000022,"d":"-0.1"},{"v":-0.5661385170723006,"d":"-0.57"},{"v":0.4083390425580089,"d":"0.41"}]
["Pearson Correlation Formula"," SZXZY / (n -1)"," r",{"v":0.9745691815717796,"d":"0.9746"},"←11",1,{"v":0.20000000000000007,"d":"0.2"},{"v":0.24042351841717258,"d":"0.24"},1.65,{"v":0.12499999999999978,"d":"0.1"},{"v":0.5661385170722985,"d":"0.57"},{"v":0.13611301418600252,"d":"0.14"}]
["Pearson Correlation Function","CORREL"," r",{"v":0.974569181571777,"d":"0.9746"},"←12",1.5,{"v":0.7000000000000001,"d":"0.7"},{"v":0.8414823144601038,"d":"0.84"},1.7,{"v":0.17499999999999982,"d":"0.2"},{"v":0.7925939239012185,"d":"0.79"},{"v":0.6669537695114127,"d":"0.67"}]
["Degrees of freedom for t","n - 2 for t","d.f.2",{"v":4,"d":"4.00"},"←13",2,{"v":1.2000000000000002,"d":"1.2"},{"v":1.4425411105030352,"d":"1.44"},1.8,{"v":0.2749999999999999,"d":"0.3"},{"v":1.2455047375590584,"d":"1.25"},{"v":1.7966917872552357,"d":"1.80"}]
["Coefficient of Determination","r2","r2",{"v":0.9497850896694884,"d":"0.95"},"←14",null,"","",null,"","",""]
["Coefficient of Non-determination","1 - r2","k2",{"v":0.05021491033051162,"d":"0.050"},"←15",null,"","",null,"","",""]
[null,"df2/k2",null,{"v":79.65761511216952,"d":"79.658"},"←16",null,"","",null,"","",""]
["Square Root of d13","(df2/k2)^.5","Ö(df2/k2)",{"v":8.925111490181482,"d":"8.9251"},"←17",null,"","",null,"","",""]
["Test Statistic: t for Pearson","r*Ö(df2/k2)","t",{"v":8.69813860042303,"d":"8.6981"},"←18",null,"","",null,"","",""]
["Absolute value of t","ABS","|t|",{"v":8.69813860042303,"d":"8.6981"},"←19",null,"","",null,"","",""]
[{"$nulls":3},"P(t)","Tails"]
["1 Tailed probability ","TDIST, d.f.2 = n-2","p1",{"v":0.00048093319819243605,"d":"0.0005"},1]
["2 Tailed probability","2 * p1","p2",{"v":0.0009618663963848721,"d":"0.0010"},2]
["H0: r = 0; H1: r /= 0","a",0.05,"p<a - Reject H0"]
["if p2 < a then reject H0  ",null,null,"p<a - Reject H0"]
[]
["Check work with extra data set below",null,5,2]
[null,null,6,5]
[null,null,3,3]
[null,null,7,1]
[null,null,8,2]
[null,null,2,5]
[null,null,4,7]
[null,null,"|t|",{"v":1.428895477895903,"d":"1.4289"},"←19"]
[{"$nulls":3},"P(t)","Tails"]
[null,null,"p1",{"v":0.10620550273190776,"d":"0.1062"},1]
[null,null,"p2",{"v":0.21241100546381553,"d":"0.2124"},2]

{"sheet":"11B","index":13,"n_rows":29,"n_cols":15,"rows_kept":29,"flags":["formulas_cached_only"]}
["Spearman Correlation","Formula or",{"$nulls":4},"Ranks",null,"Ranks",null,null,"Spearman Table"]
["Name","Function","Symbol",null,"Score","X","X†","Y","Y†","d","d2","N/a",0.1,0.05,0.01]
["Acceptable Risk","Given information","a",0.05,1,90,4,150000,3,1,1,5,{"v":0.9,"d":"0.900"},{"v":1,"d":"1.000"}]
["Sum of the differences in ranks","SUM","Sd2",70,2,60,5,200000,2,3,9,6,0.829,0.886,{"v":1,"d":"1.000"}]
[null,"6*Sd2",null,420,3,109,3,75000,4,-1,1,7,0.715,0.786,0.929]
["Sample size = Number of pairs","COUNT column f","np",6,4,155,2,60000,5,-3,9,8,{"v":0.62,"d":"0.620"},0.715,0.881]
[null,"n2",null,36,5,36,6,250000,1,5,25,9,{"v":0.6,"d":"0.600"},{"v":0.7,"d":"0.700"},0.834]
[null,"n2 -1",null,35,6,180,1,50000,6,-5,25,10,0.564,0.649,0.794]
[null,"n(n2 -1)",null,210,7,null,"",null,"","","",11,0.537,0.619,0.764]
[null,"6Sd2/n(n2 -1)",null,{"v":2,"d":"2.000"},8,null,"",null,"","","",12,0.504,0.588,0.735]
["Spearman Correlation Formula","1-6Sd2/n(n2 -1)","rs computed",{"v":-1,"d":"-1.000"},9,null,"",null,"","","",13,0.484,0.561,0.704]
["Spearman Correlation Function","CORREL on ranks","rs computed",{"v":-1,"d":"-1.000"},10,null,"",null,"","","",14,0.464,0.539,{"v":0.68,"d":"0.680"}]
["Absolute Value of Spearman","ABS","|rs|",{"v":1,"d":"1.000"},11,null,"",null,"","","",15,0.447,0.522,0.658]
["Critical Value for rs (2 tail test)",null,"rs table",0.886,12,null,"",null,"","","",16,{"v":0.43,"d":"0.430"},0.503,0.636]
["H0: rs = 0; rs /= 0",{"$nulls":3},13,null,"",null,"","","",17,0.415,0.488,0.618]
["If |rs| computed >= rs table reject H0 ",null,"rc<rt - Accept H0",null,14,null,"",null,"","","",18,0.402,0.474,{"v":0.6,"d":"0.600"}]
["†Adjust for tied scores for most accurate results",{"$nulls":3},15,null,"",null,"","","",19,0.392,{"v":0.46,"d":"0.460"},0.585]
["Check work with extra data set below",{"$nulls":10},20,0.381,0.447,{"v":0.57,"d":"0.570"}]
[null,"X","Y",{"$nulls":8},21,0.371,0.437,0.556]
[null,"Score","Score",{"$nulls":8},22,0.361,0.426,0.544]
[null,52,225,{"$nulls":8},23,0.353,0.417,0.532]
[null,45,220,{"$nulls":8},24,0.345,0.407,0.521]
[null,61,210,{"$nulls":8},25,0.337,0.399,0.511]
[null,51,230,{"$nulls":8},26,0.331,0.391,0.501]
[null,36,265,{"$nulls":8},27,0.325,0.383,0.493]
[null,38,241,{"$nulls":8},28,0.319,0.376,0.484]
[null,42,254,{"$nulls":8},29,0.312,0.369,0.475]
[null,54,231,{"$nulls":8},30,0.307,0.363,0.467]
[null,"rs computed",{"v":-0.7619047619047619,"d":"-0.762"}]

{"sheet":"11C","index":14,"n_rows":49,"n_cols":25,"rows_kept":49,"flags":["formulas_cached_only"]}
["Regression and Prediction Interval",{"$nulls":4},"Variable",{"$nulls":12},22,23,24,25,26,27,28]
["Name","Function or Formula","Statistic",null,null,"X","Y",{"$nulls":11},"CIt","a","t","Se","Precision","LCL","UCL"]
["Sample Mean","AVERAGE for X &Y","x",1,null,{"v":501.1666666666667,"d":"501.17"},{"v":27166.666666666668,"d":"27166.67"},{"$nulls":11},95,{"v":0.05,"d":"0.050"},{"v":2.776450855890289,"d":"2.78"},{"v":3744.488151005999,"d":"3744.49"},{"v":10396.387331731652,"d":"10396.39"},{"v":27305.67719581758,"d":"27305.68"},{"v":48098.45185928089,"d":"48098.45"}]
["Standard Deviation","STDEV for X & Y","s",2,null,{"v":193.09419117794988,"d":"193.09"},{"v":11016.654059498582,"d":"11016.65"}]
["Sample Size","COUNT for X & Y","n",3,null,6,6,16,17,18]
["Compute Pearson & Test for Significance",{"$nulls":4},"X","Y","Y'","Y-Y'","(Y-Y')2"]
["Pearson Correlation","CORREL","r",4,{"v":0.9526688690710248,"d":"0.953"},475,28000,{"v":25744.433249505393,"d":"25744.4"},{"v":2255.566750494607,"d":"2255.6"},{"v":5087581.3659368,"d":"5087581.4"}]
["Degrees of freedom for t","n - 2","d.f.t",5,4,209,14000,{"v":11286.569976961471,"d":"11286.6"},{"v":2713.430023038529,"d":"2713.4"},{"v":7362702.489926871,"d":"7362702.5"}]
["Coefficient of Determination","r2","r2",6,{"v":0.9075779740970653,"d":"0.908"},684,35000,{"v":37104.18296364704,"d":"37104.2"},{"v":-2104.182963647043,"d":"-2104.2"},{"v":4427585.944502452,"d":"4427585.9"}]
["Coefficient of Non-determination","1 - r2","k2",7,{"v":0.09242202590293469,"d":"0.0924"},359,15000,{"v":19439.500393809547,"d":"19439.5"},{"v":-4439.500393809547,"d":"-4439.5"},{"v":19709163.746635124,"d":"19709163.7"}]
["Ratio of d.f. to Coef of ND","(n - 2)/(1 - r2)","d.f ./ k2",8,{"v":43.27972646045392,"d":"43.280"},576,29000,{"v":31234.07306351643,"d":"31234.1"},{"v":-2234.073063516429,"d":"-2234.1"},{"v":4991082.453129683,"d":"4991082.5"}]
["Square Root of  E8","(d.f ./ k2)^.5","Ö(d.f ./ k2)",9,{"v":6.578732891709005,"d":"6.579"},704,42000,{"v":38191.24035256012,"d":"38191.2"},{"v":3808.7596474398815,"d":"3808.8"},{"v":14506650.051966371,"d":"14506650.1"}]
["Test Statistic: t","r * Ö(d.f ./ k2)","t",10,{"v":6.26735402386477,"d":"6.267"},null,null,"","",""]
["Absolute value","ABS","|t|",11,{"v":6.26735402386477,"d":"6.267"},null,null,"","",""]
["1 tail probability =","TDIST","p1",12,{"v":0.0016536687406481544,"d":"0.0017"},null,null,"","",""]
["2 tail probability =","2 * p1","p2",13,{"v":0.003307337481296309,"d":"0.0033"}]
["Predict Y value from X"]
["Score to predict from","Given Information","X",14,695]
["Predicted Value of Y","FORECAST","Y'",15,{"v":37702.064527549235,"d":"37702.1"}]
["Set up Prediction Interval around Y'"]
["Sum of Squares of predicted scores","SUM of Column J","S(Y-Y')2",19,{"v":56084766.052097306,"d":"56084766.05"}]
["Variance of predicted scores","S(Y-Y')2/d.f.",null,20,{"v":14021191.513024326,"d":"14021191.51"}]
["Standard Error of Estimate","(S(Y-Y')2/d.f.)^.5","se",21,{"v":3744.488151005999,"d":"3744.49"}]
["Confidence Level","Given Information","CI",22,99]
["Area in tails as %","100 - CI","%",24,1]
["Area in 2 tails as proportion","% / 100","a",25,0.01]
["Critical Value of t","TINV","C.V.",26,{"v":4.604080459102988,"d":"4.60"}]
["Precision","CV * se","Precision",27,{"v":17239.9247253894,"d":"17239.92"}]
["Absolute value of Precision","ABS","|Precision|",28,{"v":17239.9247253894,"d":"17239.92"}]
["Lower Confidence Limit","Y' - |precision|","LCL",29,{"v":20462.139802159836,"d":"20462.14"}]
["Upper Confidence Limit","Y' + |precision|","UCL",30,{"v":54941.989252938634,"d":"54941.99"}]
[null,null,"Slope",null,54.35286944565384]
["Check work with extra data set below",null,"Intercept",null,-73.17973718018038]
[]
[null,"X =",42]
[null,"CI =",99]
[null,"X","Y"]
[null,51,152]
[null,45,149]
[null,39,135]
[null,56,161]
[null,71,176]
[null,82,189]
[null,91,184]
[null,75,165]
[null,51,147]
[null," se",6.44]
[null,"LCL",120.07]
[null,"UCL",165.15]

{"sheet":"12A","index":15,"n_rows":22,"n_cols":8,"rows_kept":22,"flags":["formulas_cached_only"]}
["1-way X2","Formula or"]
["Name","Function","Symbol","Purdue","Indiana U","Notre Dame"]
["Frequency Observed","Given","fO",160,30,10]
["Sample size in all groups","SUM","n",200,200,200,200,200]
["Proportion expected","Given","p",0.82,0.12,0.06]
["Frequency Expected","n * p or Given","fE",164,24,12,"",""]
["Difference",null,"fO - fE",-4,6,-2,"",""]
["Squared Difference",null,"(fO - fE)2 ",16,36,4,"",""]
["Cell Chi-square",null,"(fO - fE)2 / fE",{"v":0.0975609756097561,"d":"0.0976"},{"v":1.5,"d":"1.5000"},{"v":0.3333333333333333,"d":"0.3333"},"",""]
["Number of categories","COUNT","Categories",3]
["Degrees of freedom","n -1","d.f.",2]
["Test Statistic: Chi-Square","SUM","X2",{"v":1.9308943089430894,"d":"1.931"}]
["Probability","CHIDIST","p",{"v":0.3808128864975534,"d":"0.381"}]
[null,"a",0.05,"p>a - Accept H0"]
["H0: fO = fE; H1: fO /= fE"]
["Retaining H0 is saying the frequencies observed do not differ from what would be expected by chance from given proportions"]
["Rejecting H0 is saying the frequencies observed differ by more than we would expect by chance from given proportions"]
["Check work with extra data set below"]
[{"$nulls":3},"Bush","Gore","Nadar","Buchanan","Browne"]
[null,null,"fO",20,15,3,2,1]
[null,null,"p",0.4,0.25,0.15,0.1,0.1]
[null,null,"p =",{"v":0.09068882347621234,"d":"0.091"}]

{"sheet":"12B","index":16,"n_rows":23,"n_cols":10,"rows_kept":23,"flags":["formulas_cached_only"]}
["2-way Chi Square"]
[null,"Sandwich"]
["Gender","2d or less","more 2d","Row Total"]
["UPS",32,11,43]
["FEDEX",35,3,38]
["Column Total",67,14,81,"Grand Total"]
[{"$nulls":9},"Cell X2"]
["Gender","Sandwich","fo","Row total","Col total","Grand total","fe","fo-fe","(fo-fe)2","(fo-fe)2/fe"]
["UPS","2d or less",32,43,67,81,{"v":35.5679012345679,"d":"35.57"},{"v":-3.5679012345678984,"d":"-3.57"},{"v":12.729919219631133,"d":"12.73"},{"v":0.35790470558490867,"d":"0.36"}]
[null,"more 2d",11,43,14,81,{"v":7.432098765432099,"d":"7.43"},{"v":3.567901234567901,"d":"3.57"},{"v":12.729919219631153,"d":"12.73"},{"v":1.7128296624420654,"d":"1.71"}]
["FEDEX","2d or less",35,38,67,81,{"v":31.432098765432098,"d":"31.43"},{"v":3.567901234567902,"d":"3.57"},{"v":12.729919219631158,"d":"12.73"},{"v":0.40499743000397637,"d":"0.40"}]
[null,"more 2d",3,38,14,81,{"v":6.567901234567901,"d":"6.57"},{"v":-3.567901234567901,"d":"-3.57"},{"v":12.729919219631153,"d":"12.73"},{"v":1.9382019864476003,"d":"1.94"}]
[]
[null,"Rows",2,"Columns",2,{"$nulls":3},"X2 =",{"v":4.413933784478551,"d":"4.41"}]
[null,"Rows -1",1,"Columns -1",1,{"$nulls":3},"p =",{"v":0.03564655485974159,"d":"0.0356"}]
[null,"d.f.",1]
[{"$nulls":7},"a",0.05,"p<a - Reject H0"]
[]
["Check work with extra data set below"]
["Major","Relationship","Money"]
["Business",23,15]
["Other",15,10]
[null,"p =",{"v":0.9666780482214903,"d":"0.9667"}]

{"sheet":"13A","index":17,"n_rows":57,"n_cols":8,"rows_kept":57,"flags":["formulas_cached_only"]}
["Simple ANOVA","Group Names",null,"Chicago","Indy","Fort Wayne"]
[null,"Score #",1,100,75,75]
[null,"Score #",2,125,90,85]
[null,"Score #",3,110,100,100]
[null,"Score #",4,150,125,105]
[null,"Score #",5]
[null,"Score #",6]
[null,"Score #",7]
[null,"Score #",8]
[null,"Score #",9]
[null,"Score #",10]
[null,"Score #",11]
[null,"Score #",12]
[null,"Score #",13]
[null,"Score #",14]
[null,"Score #",15]
["Sample Size (of each group)","COUNT","n",4,4,4,0,0]
["Total of all Sample Sizes n1 + n2 + . . . Nk","SUM","  N ",12]
["Number of Groups","COUNT","k",3]
["Sum of Squares (of each group)","DEVSQ","SS",1418.75,1325,568.75,"",""]
["Means (of each group)","AVERAGE","x",121.25,{"v":97.5,"d":"97.50"},91.25,"",""]
["Grand Mean (of all scores)","AVERAGE","x",{"v":103.33333333333333,"d":"103.33"},{"v":103.33333333333333,"d":"103.33"},{"v":103.33333333333333,"d":"103.33"},"",""]
["Deviation","xj - x",null,{"v":17.91666666666667,"d":"17.92"},{"v":-5.833333333333329,"d":"-5.83"},{"v":-12.083333333333329,"d":"-12.08"},"",""]
["Squared Deviation","(xj - x)2",null,{"v":321.0069444444446,"d":"321.01"},{"v":34.02777777777772,"d":"34.03"},{"v":146.00694444444434,"d":"146.01"},"",""]
["Weighted Squared Deviation","nj(xj - x)2",null,{"v":1284.0277777777785,"d":"1284.03"},{"v":136.1111111111109,"d":"136.11"},{"v":584.0277777777774,"d":"584.03"},"",""]
["Sum of Squares Between (for all groups)","SUM Snj(xj - x)2","SSB",{"v":2004.1666666666667,"d":"2004.17"}]
["Sum of Squares Within (for all groups)","SUM SS(X - x)2","SSW",{"v":3312.5,"d":"3312.50"}]
["Sum of Square Total (of all scores)","DEVSQ","SST",{"v":5316.666666666665,"d":"5316.67"}]
["Degrees of Freedom Between","k -1","d.f.B",2]
["Degrees of Freedom Within","N - k","d.f.W",9]
["Degress of Freedom Total","N - 1","d.f.T",11]
["Mean Square Between","SSB / dfB","MSB",{"v":1002.0833333333334,"d":"1002.08"}]
["Mean Square Within","SSW / dfW","MSW",{"v":368.05555555555554,"d":"368.06"}]
["Test Statistics: F","MSB / MSW","F",{"v":2.7226415094339624,"d":"2.72"}]
["Probability","FDIST","p",{"v":0.11893893467131794,"d":"0.12"}]
[null,null,"Source","SS","d.f.","MS","F","p"]
["Between the Means","Snj(xj - x)2","SSB",{"v":2004.1666666666667,"d":"2004.17"},2,{"v":1002.0833333333334,"d":"1002.08"},2.7226415094339624,0.11893893467131794]
["Within the Groups","SS(X - x)2","SSW",{"v":3312.5,"d":"3312.50"},9,{"v":368.05555555555554,"d":"368.06"}]
["Sum of Squares Total","SSB + SSW","SST",{"v":5316.666666666667,"d":"5316.67"}]
[]
[{"$nulls":5},"a",0.05,"p>a - Accept H0"]
[]
[]
["Check work with data below"]
[{"$nulls":3},"Papa J","Domino","Pz Hut","CiCi"]
[{"$nulls":3},9,5,9,3]
[{"$nulls":3},8,6,8,4]
[{"$nulls":3},6,8,7,5]
[{"$nulls":3},7,7,6,3]
[{"$nulls":3},5,5,null,4]
[{"$nulls":3},9,2,null,1]
[{"$nulls":3},8]
[]
[null,null,"Source","SS","d.f.","MS","F","p"]
[null,null,"SSB",{"v":67.06107660455487,"d":"67.06"},3,{"v":22.35369220151829,"d":"22.35"},8.571958854786926,0.0008338803988747326]
[null,null,"SSW",{"v":49.54761904761905,"d":"49.55"},19,{"v":2.6077694235588975,"d":"2.61"}]
[null,null,"SST",{"v":116.60869565217392,"d":"116.61"}]

{"sheet":"13B","index":18,"n_rows":98,"n_cols":10,"rows_kept":98,"merged":[[71,0,72,0],[71,1,71,9],[73,0,74,0],[73,1,74,1],[73,4,74,4],[73,5,74,5],[73,7,74,7],[73,8,74,8],[75,0,76,0],[75,1,76,1],[75,2,76,2],[75,3,76,3],[75,4,76,4],[75,6,76,6],[75,7,76,7],[75,8,76,8],[77,0,78,0],[77,1,78,1],[77,2,78,2],[77,3,78,3],[77,4,78,4],[77,5,78,5],[77,6,78,6]],"flags":["formulas_cached_only"]}
["Simple ANOVA","Group Names",null,"A","B","C","D"]
[null,"Score #",1,24,36,24,30]
[null,"Score #",2,36,48,29,32]
[null,"Score #",3,12,50,21,29]
[null,"Score #",4,11,39,30,31]
[null,"Score #",5,5,38,28,33]
[null,"Score #",6,30,42,22,35]
[null,"Score #",7,21,46,27,28]
[null,"Score #",8,32,37,24,32]
[null,"Score #",9,15,47,26,33]
[null,"Score #",10,7,44,25,35]
[null,"Score #",11]
[null,"Score #",12]
[null,"Score #",13]
[null,"Score #",14]
[null,"Score #",15]
["Sample Size (of each group)","COUNT","n",10,10,10,10,""]
["Total of all Sample Sizes","SUM","  N ",40]
["Number of Groups","COUNT","k",4]
["Sum of Squares (of each group)","DEVSQ","SS",{"v":1076.1,"d":"1076.1000"},{"v":226.10000000000002,"d":"226.1000"},{"v":78.39999999999999,"d":"78.4000"},{"v":49.599999999999994,"d":"49.6000"},""]
["Means (of each group)","AVERAGE","x1",{"v":19.3,"d":"19.30"},{"v":42.7,"d":"42.70"},{"v":25.6,"d":"25.60"},{"v":31.8,"d":"31.80"},""]
["Grand Mean (of all scores)","AVERAGE","x",29.85,29.85,29.85,29.85,""]
["Deviation","xj - x",null,-10.55,{"v":12.850000000000001,"d":"12.85"},-4.25,{"v":1.9499999999999993,"d":"1.95"},""]
["Squared Deviation","(xj - x)2",null,{"v":111.30250000000001,"d":"111.30"},{"v":165.12250000000003,"d":"165.12"},{"v":18.0625,"d":"18.06"},{"v":3.802499999999997,"d":"3.80"},""]
["Weighted Squared Deviation","nj(xj - x)2",null,{"v":1113.025,"d":"1113.03"},{"v":1651.2250000000004,"d":"1651.23"},{"v":180.625,"d":"180.63"},{"v":38.02499999999997,"d":"38.03"},""]
["Sum of Squares Between (for all groups)","SUM Snj(xj - x)2","SSB",{"v":2982.9000000000005,"d":"2982.90"}]
["Sum of Squares Within (for all groups)","SUM SS(X - x)2","SSW",{"v":1430.1999999999998,"d":"1430.20"}]
["Sum of Square Total (of all scores)","DEVSQ","SST",{"v":4413.1,"d":"4413.10"}]
["Degrees of Freedom Between","k -1","d.f.B",3]
["Degrees of Freedom Within","N - k","d.f.W",36]
["Degress of Freedom Total","N - 1","d.f.T",39]
["Mean Square Between","SSB / dfB","MSB",{"v":994.3000000000002,"d":"994.30"}]
["Mean Square Within","SSW / dfW","MSW",{"v":39.727777777777774,"d":"39.73"}]
["Test Statistics: F","MSB / MSW","F",{"v":25.027828275765636,"d":"25.03"}]
["Probability","FDIST","p",{"v":6.324981007171372e-09,"d":"0.00000"}]
[null,null,"Source","SS","d.f.","MS","F","p"]
["Between the Means","Snj(xj - x)2","SSB",{"v":2982.9000000000005,"d":"2982.90"},3,{"v":994.3000000000002,"d":"994.30"},{"v":25.027828275765636,"d":"25.028"},{"v":6.324981007171372e-09,"d":"0.00000"}]
["Within the Groups","SS(X - x)2","SSW",{"v":1430.1999999999998,"d":"1430.20"},36,{"v":39.727777777777774,"d":"39.73"}]
["Sum of Squares Total","SSB + SSW","SST",{"v":4413.1,"d":"4413.10"},null,"a",0.05,"p<a - Reject H0, there is a difference between some pairs"]
[]
["Eta-squared","SSB / SST* 100","h2",{"v":67.59194217216923,"d":"67.59"}]
[]
["Group 1",null,null,"A","A","A","B","B","C"]
["vs",null,null,"vs","vs","vs","vs","vs","vs"]
["Group 2",null,null,"B","C","D","C","D","D"]
["Difference in Means",null,"x1-x2 ",{"$nulls":6},"Both"]
["Tukey use if n's are equal"]
["Absolute Value of Difference in Means","ABS","|x1-x2|",{"v":23.400000000000002,"d":"23.40"},{"v":6.300000000000001,"d":"6.30"},{"v":12.5,"d":"12.50"},{"v":17.1,"d":"17.10"},{"v":10.900000000000002,"d":"10.90"},{"v":6.199999999999999,"d":"6.20"},"Tukey"]
["Tabled value for Tukey for .05","q for 0.05","q",3.85,3.85,3.85,3.85,3.85,3.85,"Tukey"]
["Tabled value for Tukey for .01","q for 0.01","q",{"v":4.8,"d":"4.80"},4.8,4.8,4.8,4.8,4.8,"Tukey"]
["Means Square Within / n","MSW/n","MSW / n",{"v":3.9727777777777775,"d":"3.9728"},{"v":3.9727777777777775,"d":"3.9728"},{"v":3.9727777777777775,"d":"3.9728"},{"v":3.9727777777777775,"d":"3.9728"},{"v":3.9727777777777775,"d":"3.9728"},{"v":3.9727777777777775,"d":"3.9728"},"Tukey"]
["Square Root (Means Square Within / n)","(MSW/n)^.5","(MSW / n).5",{"v":1.9931828259790363,"d":"1.9932"},{"v":1.9931828259790363,"d":"1.9932"},{"v":1.9931828259790363,"d":"1.9932"},{"v":1.9931828259790363,"d":"1.9932"},{"v":1.9931828259790363,"d":"1.9932"},{"v":1.9931828259790363,"d":"1.9932"},"Tukey"]
["Tukey Value for a = .05","q.05 * (MSw/n)^.5","TV.05",{"v":7.67375388001929,"d":"7.6738"},{"v":7.67375388001929,"d":"7.6738"},{"v":7.67375388001929,"d":"7.6738"},{"v":7.67375388001929,"d":"7.6738"},{"v":7.67375388001929,"d":"7.6738"},{"v":7.67375388001929,"d":"7.6738"},"Tukey"]
["Tukey Value for a = .01","q.01 * (MSw/n)^.5","TV.01",{"v":9.567277564699374,"d":"9.5673"},{"v":9.567277564699374,"d":"9.5673"},{"v":9.567277564699374,"d":"9.5673"},{"v":9.567277564699374,"d":"9.5673"},{"v":9.567277564699374,"d":"9.5673"},{"v":9.567277564699374,"d":"9.5673"},"Tukey"]
["Critial Value.05: if positive reject H0","|x1-x2| - TV.05 ","CV.05",{"v":15.726246119980711,"d":"15.7262"},{"v":-1.3737538800192892,"d":"-1.3738"},{"v":4.82624611998071,"d":"4.8262"},{"v":9.42624611998071,"d":"9.4262"},{"v":3.226246119980712,"d":"3.2262"},{"v":-1.4737538800192906,"d":"-1.4738"},"Tukey"]
["Critial Value.01: if positive reject H0","|x1-x2| - TV.01","CV.01",{"v":13.832722435300628,"d":"13.8327"},{"v":-3.2672775646993735,"d":"-3.2673"},{"v":2.932722435300626,"d":"2.9327"},{"v":7.532722435300627,"d":"7.5327"},{"v":1.332722435300628,"d":"1.3327"},{"v":-3.367277564699375,"d":"-3.3673"},"Tukey"]
["Scheffe use if n's are not equal"]
["Square of difference in mean","(x1-x2)^2","(x1-x2)2 ","n Equal","n Equal","n Equal","n Equal","n Equal","n Equal","Scheffe"]
["Reciprocal of first sample size","1 / n1","1 / n1","n Equal","n Equal","n Equal","n Equal","n Equal","n Equal","Scheffe"]
["Reciprocal of second sample size","1 / n2","1 / n2","n Equal","n Equal","n Equal","n Equal","n Equal","n Equal","Scheffe"]
["Sum of reciprocals","1 / n1 + 1 / n2",null,"n Equal","n Equal","n Equal","n Equal","n Equal","n Equal","Scheffe"]
["Product of Sum of reciprocals, dfb & MSW","=$D29*$D33*D61",null,"n Equal","n Equal","n Equal","n Equal","n Equal","n Equal","Scheffe"]
["Scheffe Value","=d58/d62","Fs","n Equal","n Equal","n Equal","n Equal","n Equal","n Equal","Scheffe"]
["Probability of type 1 error in Rejecting H0","FDIST","p","n Equal","n Equal","n Equal","n Equal","n Equal","n Equal","Scheffe"]
[]
["Table is available at "]
["http://www.umr.edu/~rhall/virtualstat/tukeys/criticaltable.html"]
[]
[]
["The critical values for q corresponding to alpha = .05 (top) and alpha = .01 (bottom)"]
[]
["df for Error Term","k= Number of Treatments"]
[null,2,3,4,5,6,7,3,9,10]
[5,"3.64  5.70",4.6,5.22,"5.67 8.42","6.03 8.91",6.33,"6.58 9.67","6.80 9.97",6.99]
[null,null,6.98,7.8,null,null,9.32,null,null,10.24]
[6,"3.46 5.24","4.34 6.33","4.90 7.03","5.30 7.56",5.63,"5.90 8.32","6.12 8.61","6.32 8.87",6.49]
[{"$nulls":5},7.97,{"$nulls":3},9.1]
[7,"3.34 4.95","4.16 5.92","4.68 6.54","5.06 7.01","5.36 7.37","5.61 7.68",5.82,6,6.16]
[{"$nulls":7},7.94,8.17,8.37]
[8,"3.26 4.75","4.04 5.64","4.53 6.20","4.89 6.62","5.17 6.96","5.40 7.24","5.60 7.47","5.77 7.68","5.92 7.86"]
[9,"3.20 4.60","3.95 5.43","4.41 5.96","4.76 6.35","5.02 6.66","5.24 6.91","5.43 7.13","5.59 7.33","5.74 7.49"]
[10,"3.15 4.48","3.88 5.27","4.33 5.77","4.65 6.14","4.91 6.43","5.12 6.67","5.30 6.87","5.46 7.05","5.60 7.21"]
[11,"3.11 4.39","3.82 5.15","4.26 5.62","4.57 5.97","4.82 6.25","5.03 6.48","5.20 6.67","5.35 6.84","5.49 6.99"]
[12,"3.08 4.32","3.77 5.05","4.20 5.50","4.51 5.84","4.75 6.10","4.95 6.32","5.12 6.51","5.27 6.67","5.39 6.81"]
[13,"3.06 4.26","3.73 4.96","4.15 5.40","4.45 5.73","4.69 5.98","4.88 6.19","5.05 6.37","5.19 6.53","5.32 6.67"]
[14,"3.03 4.21","3.70 4.89","4.11 5.32","4.41 5.63","4.64 5.88","4.83 6.08","4.99 6.26","5.13 6.41","5.25 6.54"]
[15,"3.01 4.17","3.67 4.84","4.08 5.25","4.37 5.56","4.59 5.80","4.78 5.99","4.94 6.16","5.08 6.31","5.20 6.44"]
[16,"3.00 4.13","3.65 4.79","4.05 5.19","4.33 5.49","4.56 5.72","4.74 5.92","4.90 6.08","5.03 6.22","5.15 6.35"]
[17,"2.98 4.10","3.63 4.74","4.02 5.14","4.30 5.43","4.52 5.66","4.70 5.85","4.86 6.01","4.99 6.15","5.11 6.27"]
[18,"2.97 4.07","3.61 4.70","4.00 5.09","4.28 5.38","4.49 5.60","4.67 5.79","4.82 5.94","4.96 6.08","5.07 6.20"]
[19,"2.96 4.05","3.59 4.67","3.98 5.05","4.25 5.33","4.47 5.55","4.65 5.73","4.79 5.89","4.92 6.02","5.04 6.14"]
[20,"2.95 4.02","3.58 4.64","3.96 5.02","4.23 5.29","4.45 5.51","4.62 5.69","4.77 5.84","4.90 5.97","5.01 6.09"]
[24,"2.92 3.96","3.53 4.55","3.90 4.91","4.17 5.17","4.37 5.37","4.54 5.54","4.68 5.69","4.81 5.81","4.92 5.92"]
[30,"2.89 3.89","3.49 4.45","3.85 4.80","4.10 5.05","4.30 5.24","4.46 5.40","4.60 5.54","4.72 5.65","4.82 5.76"]
[40,"2.86 3.82","3.44 4.37","3.79 4.70","4.04 4.93","4.23 5.11","4.39 5.26","4.52 5.39","4.63 5.50","4.73 5.60"]
[60,"2.83 3.76","3.40 4.28","3.74 4.59","3.98 4.82","4.16 4.99","4.31 5.13","4.44 5.25","4.55 5.36","4.65 5.45"]
[120,"2.80 3.70","3.36 4.20","3.68 4.50","3.92 4.71","4.10 4.87","4.24 5.01","4.36 5.12","4.47 5.21","4.56 5.30"]
["infinity","2.77 3.64","3.31 4.12","3.63 4.40","3.86 4.60","4.03 4.76","4.17 4.88","4.29 4.99","4.39 5.08","4.47 5.16"]

{"sheet":"Bar","index":19,"n_rows":15,"n_cols":7,"rows_kept":15,"merged":[[5,0,5,8],[6,1,6,2],[6,3,6,4],[6,5,6,6]],"flags":["formulas_cached_only"]}
["Percentage of the population in large industrialized countries "]
["who had completed secondary and higher education, by age, sex, and country: 1994"]
["source: http://nces.ed.gov/pubs/ce/c9723a01.html"]
["Construct 2 graphs. The first to show which country has the lowest higher education rate."]
[null,"The second graph should show which country has the most gender difference in higher education rate."]
["Percentage of the population in large industrialized countries who had completed education."]
[null,"Total",null,"Male",null,"Female"]
["Country","Secondary","Higher","Secondary","Higher","Secondary","Higher"]
["Canada",74.1,16.9,80.6,18,84,18.9]
["France",67.1,9.2,86.4,11.9,82.3,11.3]
["Germany",84,12.6,91.6,12.7,87.5,11]
["Italy",33.2,7.5,45.6,7.7,49,8.1]
["Japan",69.7,13.3,89.3,34.2,91.8,11.5]
["UnitedKingdom",74.5,11.7,87.3,15.7,84.9,11.7]
["UnitedStates",85.1,24.4,85.2,23.4,87.5,23.5]

{"sheet":"Pareto","index":20,"n_rows":9,"n_cols":2,"rows_kept":9,"merged":[[3,0,3,5]],"flags":["formulas_cached_only"]}
["Contruct a pareto diagram to dramatize the most frequent type of noncomformity"]
["Construct a pie chart."]
[]
["Frequency of defects in returned Boom Boxes"]
["Surface Blemish",105]
["Tape Jams in Player",51]
["Screen fail to light up.",10]
["Radio does not work",8]
["Smokes",6]

{"sheet":"Histogram","index":21,"n_rows":7,"n_cols":2,"rows_kept":7,"flags":["formulas_cached_only"]}
["Supervisor Rating of Employee's Performance"]
["Rating","Frequency"]
["Unacceptable",8]
["Acceptable",5]
["Above Average",2]
["Excellent",4]
["Outstanding",2]

{"sheet":"Data Curve","index":22,"n_rows":6,"n_cols":2,"rows_kept":6,"flags":["formulas_cached_only"]}
["Incentive Pay in $","Output in Units"]
[0,15]
[25,10]
[50,25]
[75,35]
[100,30]

{"sheet":"Time Series","index":23,"n_rows":16,"n_cols":2,"rows_kept":16,"flags":["formulas_cached_only"]}
["Per capita personal income"]
["Year","Income"]
[1993,21220]
[1994,22056]
[1995,23063]
[1996,24169]
[1997,25298]
[1998,26240]
[1999,27002]
[2000,25006]
[]
[]
[]
[]
[]
["Construct a time series graph to show the trend in personal income."]